CREATE TABLE [dbo].[Ref_Client]
(
[CLIENT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_CLIENT_ID] DEFAULT (''),
[FIRST_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_FIRST_NAME] DEFAULT (''),
[MIDDLE_NAME] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_MIDDLE_NAME] DEFAULT (''),
[LAST_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_LAST_NAME] DEFAULT (''),
[LAST_FIRST] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_LAST_FIRST] DEFAULT (''),
[COMPANY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_COMPANY] DEFAULT (''),
[ADDRESS_1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_ADDRESS_2] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_CITY] DEFAULT (''),
[STATE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_STATE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_ZIP] DEFAULT (''),
[COUNTY] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_COUNTY] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_COUNTRY] DEFAULT (''),
[PHONE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_PHONE] DEFAULT (''),
[FAX] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_FAX] DEFAULT (''),
[DATE_CREATED] [datetime] NULL,
[DATE_UPDATED] [datetime] NULL,
[NOTE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_NOTE] DEFAULT (''),
[CLIENT_TYPE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_CLIENT_TYPE] DEFAULT (''),
[EMAIL] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_EMAIL] DEFAULT (''),
[ADDRESS_3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Client_ADDRESS_3] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Ref_Client] ADD CONSTRAINT [PK_Ref_Client] PRIMARY KEY NONCLUSTERED ([CLIENT_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ClientDATE_CREATED] ON [dbo].[Ref_Client] ([DATE_CREATED]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ClientDATE_UPDATED] ON [dbo].[Ref_Client] ([DATE_UPDATED]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ClientLAST_FIRST] ON [dbo].[Ref_Client] ([LAST_FIRST]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Ref_Client] TO [IMIS]
GRANT SELECT ON  [dbo].[Ref_Client] TO [IMIS]
GRANT INSERT ON  [dbo].[Ref_Client] TO [IMIS]
GRANT DELETE ON  [dbo].[Ref_Client] TO [IMIS]
GRANT UPDATE ON  [dbo].[Ref_Client] TO [IMIS]
GO